select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Beautiful Ball gown Beading and Ruffles Sweetheart Quinceanera Dresses
Royal Blue Ball Gown Sweetheart Appliques and Ruffles Quinceanera Dresses
Gorgeous Beaded Decorate Ball gown Sweetheart Quinceanera Dresses in Rose Pink
Brand New Beaded Decorate Bodice Ball Gown Sweetheart Aqua Blue Quinceanera Dresses
Sweetheart Ball Gown Aqua Blue Quinceanera Dresses with Sequins and Ruffles
Exclusive Beading Ball Gown Strapless Quinceanera Dresses with Leopard
Sweet Baby Pink Ball Gown Strapless Beaded Decorate Quinceanera Dresses
Unique Yellow Ball Gown Sweetheart Ruffles Quinceanera Dresses with Court Train
Spaghetti Straps Ball Gown Organza Red Quinceanera Dresses with Appliques
Simple Ball Gown Strapless Applique and Beading Quincenera Dresses in White
New Beading and Ruffles Ball Gown Sweetheart Red And Black Quinceanera Dresses
Wonderful Hot Pink Ball gown Sweetheart Beading and Ruffles Quinceanera Dresses
Romantic Ball Gown Sweetheart Appliques and Beading Quinceanera Dresses in Multi Color
Beautiful Appliques Ball Gown Sweetheart Quinceanera Dresses with Court Train
Lovely Appliques and Beading Ball Gown Strapless Quinceanera Dresses
Purple Elegant Ball Gown Sweetheart Appliques And Ruffles Quinceanera Dresses
Luxurious Ball Gown Strapless Beading And Ruffled Layers Quinceanera Dresses in Hot Pink
The Most Popular Ball Gowns Sweetheart Floor-length Quincenera Dresses
Special ball gown sweetheart-neck floor-length quinceanera dresses
All Colors Strapless Ruffles and Beading Embroidery Sweet 16 Dresses for 2014 Spring
Bowknot Ball Gown Halter Top Turquoise And White Beading Little Girl Pageant Dresses Hottest
Ball Gown Straps Floor-length Light Blue Beading Little Girl Pageant Dresses
Beautiful White Ball gown Organza One Shoulder Floor-length Beading Little Girl Pageant Dresses
Ball Gown Strapless Rose Pink Little Girl Pageant Dresses for Birthday Party
Pretty Beading Pink Wedding Party Shawls for 2014
High-low Beaded Sweetheart Chiffon 16 Birthday Party Dress In Wine Red
Sweetheart Appliques Rose Pink 16 Birthday Party Dress with Beading
Baby Pink Ruched Bodice Hand Made Flowers Decorate For 16 Birthday Party Dress
Mermaid Ruching Sweetheart Beaded Coral Red 16 Birthday Party Dress
Lavender Sweetheart 16 Birthday Party Dress with Pink Sash